UPDATE project SET alphaidentifier = '0A' WHERE alphaidentifier = 'OA';
UPDATE project SET alphaidentifier = '0B' WHERE alphaidentifier = 'OB';
UPDATE project SET alphaidentifier = '0C' WHERE alphaidentifier = 'OC';
UPDATE project SET alphaidentifier = '0D' WHERE alphaidentifier = 'OD';
UPDATE project SET alphaidentifier = '0E' WHERE alphaidentifier = 'OE';
UPDATE project SET alphaidentifier = '0F' WHERE alphaidentifier = 'OF';
UPDATE project SET alphaidentifier = '0G' WHERE alphaidentifier = 'OG';
UPDATE project SET alphaidentifier = '0H' WHERE alphaidentifier = 'OH';
UPDATE project SET alphaidentifier = '0I' WHERE alphaidentifier = 'OI';
UPDATE project SET alphaidentifier = '0J' WHERE alphaidentifier = 'OJ';
UPDATE project SET alphaidentifier = '0K' WHERE alphaidentifier = 'OK';
UPDATE project SET alphaidentifier = '0L' WHERE alphaidentifier = 'OL';
UPDATE project SET alphaidentifier = '0M' WHERE alphaidentifier = 'OM';
UPDATE project SET alphaidentifier = '0N' WHERE alphaidentifier = 'ON';
UPDATE project SET alphaidentifier = '0O' WHERE alphaidentifier = 'OO';
UPDATE project SET alphaidentifier = '0P' WHERE alphaidentifier = 'OP';
UPDATE project SET alphaidentifier = '0Q' WHERE alphaidentifier = 'OQ';
UPDATE project SET alphaidentifier = '0R' WHERE alphaidentifier = 'OR';
UPDATE project SET alphaidentifier = '0S' WHERE alphaidentifier = 'OS';
UPDATE project SET alphaidentifier = '0T' WHERE alphaidentifier = 'OT';
UPDATE project SET alphaidentifier = '0U' WHERE alphaidentifier = 'OU';
UPDATE project SET alphaidentifier = '0V' WHERE alphaidentifier = 'OV';
UPDATE project SET alphaidentifier = '0W' WHERE alphaidentifier = 'OW';
UPDATE project SET alphaidentifier = '0X' WHERE alphaidentifier = 'OX';
UPDATE project SET alphaidentifier = '0Y' WHERE alphaidentifier = 'OY';
UPDATE project SET alphaidentifier = '0Z' WHERE alphaidentifier = 'OZ';
GO